Hi everyone, i have a small problem with a spreedsheet i'm currently designing. I'm using the TODAY date function linked to a checkbox. So when i tick the checkbox, Todays date appears in cell 'g33'. However, i don't want the date to change, i want it to remain.
i.e. If i ticked the box on the 2nd of January, reload the software on the 5th, i want the date to remain as the 2nd.
I've looked about trying to find a few formulas but have had so far no joy. Any help would be great.
TickBox linked too $AA$4
Cell G33 (where date will appear) =IF(AA4,AA9,AA10)
AA9 =TODAY()
AA10 =-
Cheers for any help/advise you can give me
i.e. If i ticked the box on the 2nd of January, reload the software on the 5th, i want the date to remain as the 2nd.
I've looked about trying to find a few formulas but have had so far no joy. Any help would be great.
TickBox linked too $AA$4
Cell G33 (where date will appear) =IF(AA4,AA9,AA10)
AA9 =TODAY()
AA10 =-
Cheers for any help/advise you can give me