Boroproud Well-known member Nov 10, 2021 #1 I'm trying to create a simple formula ( at least I would normally think so) but can I heck get my head round it. Total brain freeze If I put yesterday's date in A1. Then in A2 I want to count how many days to today. Then ongoing. What the flip is it ? TIA
I'm trying to create a simple formula ( at least I would normally think so) but can I heck get my head round it. Total brain freeze If I put yesterday's date in A1. Then in A2 I want to count how many days to today. Then ongoing. What the flip is it ? TIA
Boroproud Well-known member Nov 10, 2021 #3 Rauko said: =Today()-A1 Click to expand... That's what I was thinking mate. But that just the date back. Eg 22/09/21 in A1 , instead of saying 0 days in B2 it says 18/02/1900. Baffles me
Rauko said: =Today()-A1 Click to expand... That's what I was thinking mate. But that just the date back. Eg 22/09/21 in A1 , instead of saying 0 days in B2 it says 18/02/1900. Baffles me
Steer Well-known member Nov 10, 2021 #4 Change format of the answer cell into a number instead of a date
Boroproud Well-known member Nov 10, 2021 #5 Steer said: Change format of the answer cell into a number instead of a date Click to expand... FFS How easy was that Cheers mate, thanks also to Rauko
Steer said: Change format of the answer cell into a number instead of a date Click to expand... FFS How easy was that Cheers mate, thanks also to Rauko