Return text and date in header

[DavoP]

Hi,

See attached sheet which is part of a year calculating hours and pay weekly ... something for me to monitor cause our pay clerk makes SSOOO many mistakes.

Anyway I'll create more data below what you see here and this is where it becomes tedious. Putting the dates in column "B" isn't so bad but I just want to make it easier for myself in cells that are merged (ROW 13) as the title "WE(DATE) at the very top.

Due to the fact I have the date column formatted as DATE and not GENERAL. when I type this formular ="WE" &B21 it gives me the result in B24.

This formular need to be in the header cell of each week so it automated to fill in when I put my Sunday date in.

I certainly hope this all makes sense.

Thanks for taking the time to look at this for me

[Glenn Kennedy]

You don't tell us which sheet to look at, and there's nothing odd-looking in B24 in either sheet.

try this (a guess) in Sheet1 B1, copied down as needed.

If not, upload a sample with clearly demostrated expected answers!!

="WE: "&TEXT(LEFT(B3,5)+6,"dd mmmm yy")

[Glenn Kennedy]

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Since you are a very infrequent user of this site, on this occasion, I have changed it for you.

However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.




Regards,

Glenn.

[Glenn Kennedy]

Please note. I goofed up and changed the formula and the attachment in Post 2.

[protonLeah]

If you can do without those ordinal suffixes on the day (21st) then you can use the first block as a template and put =B10 in cell B2; but B2 custom formatted "WE" dd mmmm yyyy: WE 14 May 2023 vs. WE 14th May 2023