Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


DamageInc

496 posts

Ultimate Geek

Lifetime subscriber

#295507 2-Apr-2022 17:59
Send private message

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


Filter this topic showing only the reply marked as answer Create new topic
kiwifidget
"Cookie"
2861 posts

Uber Geek

Lifetime subscriber

  #2895843 2-Apr-2022 18:06
Send private message

it would be 1/3s if that helps.





Delete cookies?! Are you insane?!


 
 
 

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

496 posts

Ultimate Geek

Lifetime subscriber

  #2895844 2-Apr-2022 18:08
Send private message

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
Send private message

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
"Cookie"
2861 posts

Uber Geek

Lifetime subscriber

  #2895849 2-Apr-2022 18:16
Send private message

Or you could use DATEDIF

 

 

 

 





Delete cookies?! Are you insane?!


DamageInc

496 posts

Ultimate Geek

Lifetime subscriber

  #2895852 2-Apr-2022 18:24
Send private message

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


Filter this topic showing only the reply marked as answer Create new topic





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.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.







Backblaze unlimited backup