Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.

## DamageInc

496 posts

Ultimate Geek

#295507 2-Apr-2022 17:59

Hello,

Was wondering if i could get some help please.

If i had the numbers 1(start) - 30(end), the numbers in between i want are 10 & 20. How do i do that with dates?

Random example:

Cell A1 has the start date 1/1/2022

Cell A2 is empty

Cell A3 is empty

Cell A4 has the end date 14/3/2022

What would the formula be to find the dates to fill cells A2 & A3?

I know in cell A2 i can do =AVERAGE(A1,A4) & that will give me the middle date between start date & end date. But i would like to fill both empty cells. In 1/4's i guess?

Any help much appreciated.

Thank you

Pop! OS

## kiwifidget

2861 posts

Uber Geek

#2895843 2-Apr-2022 18:06

it would be 1/3s if that helps.

## TrendMicro

Best TrendMicro deals for antivirus and malware protection(affiliate link).

## DamageInc

496 posts

Ultimate Geek

#2895844 2-Apr-2022 18:08

1/3's or 1/4's i just don't know the formula to get the in-between dates.

Pop! OS

## Peppery

910 posts

Ultimate Geek

Trusted

#2895846 2-Apr-2022 18:11

You can add and subtract dates just like any other formula. If you subtract your end date (A4) from your start date (A1), you get 72 days. You can then add a fraction of the 72 to the start date to figure out the dates in between.

## kiwifidget

2861 posts

Uber Geek

#2895849 2-Apr-2022 18:16

Or you could use DATEDIF

## DamageInc

496 posts

Ultimate Geek

#2895852 2-Apr-2022 18:24

Peppery:

You can add and subtract dates just like any other formula. If you subtract your end date (A4) from your start date (A1), you get 72 days. You can then add a fraction of the 72 to the start date to figure out the dates in between.

You are fantastic thank you so much.

Pop! OS

News and reviews »

Prodigi Technology Services Announces Strategic Acquisition of Conex
Posted 4-Dec-2023 09:33

Samsung Announces Galaxy AI
Posted 28-Nov-2023 14:48

Epson Launches EH-LS650 Ultra Short Throw Smart Streaming Laser Projector
Posted 28-Nov-2023 14:38

Fitbit Charge 6 ReviewÂ
Posted 27-Nov-2023 16:21

Cisco Launches New Research Highlighting Gap in Preparedness for AI
Posted 23-Nov-2023 15:50

Seagate Takes Block Storage System to New Heights Reaching 2.5 PB
Posted 23-Nov-2023 15:45

Seagate Nytro 4350 NVMe SSD Delivers Consistent Application Performance and High QoS to Data Centers
Posted 23-Nov-2023 15:38

Amazon Fire TV Stick 4k Max (2nd Generation) Review
Posted 14-Nov-2023 16:17

Over half of New Zealand adults surveyed concerned about AI shopping scams
Posted 3-Nov-2023 10:42

Super Mario Bros. Wonder Launches on Nintendo Switch
Posted 24-Oct-2023 10:56

Google Releases Nest WiFi Pro in New Zealand
Posted 24-Oct-2023 10:18

Amazon Introduces All-New Echo Pop in New Zealand
Posted 23-Oct-2023 19:49

HyperX Unveils Their First Webcam and Audio Mixer Plus
Posted 20-Oct-2023 11:47

Seagate Introduces Exos 24TB Hard Drives for Hyperscalers and Enterprise Data Centres
Posted 20-Oct-2023 11:43

Dyson Zone Noise-Cancelling Headphones Comes to New Zealand
Posted 20-Oct-2023 11:33

Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.