date calculation formula builder

[sdear]

I've searched for info & studied what I could find, but not had much luck. From my latest finds, it seems there are many of us that can't get a grip on calculating with dates.

Is there a, for a lack of better term, date formula builder, out there (click on the boxes, or ...), or anyone with the knowkedge to put one together?

Or at least, a date calculation 101 site/tutorial?

 

[T. Valko]

I've searched for info & studied what I could find, but not had much luck. From my latest finds, it seems there are many of us that can't get a grip on calculating with dates.

Is there a, for a lack of better term, date formula builder, out there (click on the boxes, or ...), or anyone with the knowkedge to put one together?

Or at least, a date calculation 101 site/tutorial?

The best date formula builder in the world just happens to be a member of this forum.

Explain what you want to do and he (or someone else) may be able to help you.

 

[sdear]

My latest ventures need to find the last Saturday of the previous months.

One of them has to grab all data after the previous month's last Saturday. I need to do a couple of sorts on that data on other sheets.

Another one needs the last 3 months, sorted by month separated by a couple of blank rows. The latest month, for example, since this is Dec. 20, is from the Monday after Thanksgiving till now.

I can do everything except find the last Saturday of any month.

Excel 2007

 

[MARK858]

Have a look at the posts in the thread attached to see if it helps

http://www.mrexcel.com/forum/excel-questions/60764-last-saturday-month.html

 

[sdear]

Sorry it's taken me so long to respond (I thought i'd already done it).

It turns out I needed a few last saturday dates & I now have a way to get them.

Thank you for your help.

 

[MARK858]

Don't worry about the long response time, any response good or bad is always appreciated.
Happy my post has seemed to help you.